import pandas as pd
pd.set_option('display.unicode.east_asian_width',True)
df=pd.read_excel('城镇单位就业人员年平均工资.xlsx',sheet_name='按登记注册类型',index_col=0)
print(df)
df.drop('数据来源：国家统计局',inplace=True)
print("删除数据后的表:\n",df)
df.loc['平均工资']=[17553,19409,21016,22250,23625,26552,29594,34250,37101,41739,48869,22888,63171,69826,76302,82902,90064,99367,106604,112089]
print(df)
